
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style type="text/css">



  /* default css */
  
  table {
    font-size: 1em;
  }

  
  div, address, ol, ul, li, option, select { 
    margin-top: 0px;
    margin-bottom: 0px;
  }

  p {
    margin: 0px;
  }

  body {
    padding: 0px;
    
    
      margin: 0px;
    
  }

  h6 { font-size: 10pt }
  h5 { font-size: 11pt }
  h4 { font-size: 12pt }
  h3 { font-size: 13pt }
  h2 { font-size: 14pt }
  h1 { font-size: 16pt }

  blockquote {padding: 10px; border: 1px #DDD dashed }

  a img {border: 0}

  strike { text-decoration: line-through }

  div.google_header, div.google_footer {
    position: relative;
    margin-top: 1em;
    margin-bottom: 1em;
  }
  /* end default css */

  
    /* default print css */
    @media print {
      body { 
        padding: 0; 
        margin: 0; 
      }

      ol[type="a"] { list-style-type: lower-alpha }
      ol[type="A"] { list-style-type: upper-alpha }
      ol[type="i"] { list-style-type: lower-roman }
      ol[type="I"] { list-style-type: upper-roman }
    
      div.google_header, div.google_footer {
        display: block;
        min-height: 0;
        border: none;
      }

      div.google_header {
        flow: static(header);
      }

      /* used to insert page numbers */
      div.google_header::before, div.google_footer::before {
        position: absolute;
	top: 0;
      }

      div.google_footer {
        flow: static(footer);
      }

      /* always consider this element at the start of the doc */
      div#google_footer {
        flow: static(footer, start);
      }

      span.google_pagenumber {
        content: counter(page);
      }

      span.google_pagecount {
        content: counter(pages);
      }
    }

    @page {
      @top {
        content: flow(header);
      }
      @bottom {
        content: flow(footer);
      }
    }
    /* end default print css */
   
  
  /* custom css */
  
  
  /* end custom css */

  /* ui edited css */
  
  body {
    font-family: Verdana;
    
    font-size: 10.0pt;
    line-height: normal;
    background-color: #ffffff;
  }
  /* end ui edited css */




</style>


</head>

<body
    
    
    revision="dgtsd5n5_2hcw4p5:71">

    
    
<b><br>
1. Install
</b><a href=http://dev.mysql.com/downloads/mysql/ id=c9-6 title=MySQL>MySQL</a><br>
<b><br>
</b>It's probably a good idea to install
the<a href=http://dev.mysql.com/downloads/gui-tools/ id=fwwh title="MySQL Administrator and MySQL Query Browser">
MySQL Administrator and MySQL Query Browser</a> as well, for when you create
your own database. You can do everything from the command line, but these
graphical interfaces are easier to use.<b><br>
</b><br>
At some point, you may want to improve performance by tweaking parameters in my.ini.  Here are modifications I have made:<br><br>
<i>To be written</i><br><br>
<b><br>
2. Move ../../wpa/ to the MySQL data directory (e.g. C:\Program Files\MySQL\MySQL Server 5.1\data\) and restart MySQL.<br>
<br>
</b>wpa is the WPA Posters collection from the Library of Congress American
Memory Collection.<br>
<b><br>
3. </b><b>Create user bungee</b><b> and assign permissions<br>
</b><b><br>
</b>Substitute your own password for PASSWORD<b><br>
</b><b><br>
</b>
<div>
  <table bgcolor=#cccccc border=0 cellpadding=3 cellspacing=0 id=isuc width=100%>
    <tbody>
    <tr>
      <td width=100%>
        C:\Program Files\MySQL\MySQL Server 5.0\bin&gt;<b>mysql -u root
        -p</b><br>
        Enter password: <b>********</b><br>
        Welcome to the MySQL monitor.&nbsp; Commands end with ; or \g.<br>
        Your MySQL connection id is 15<br>
        Server version: 5.0.41-community-nt-log MySQL Community Edition (GPL)<br>
        <br>
        Type 'help;' or '\h' for help. Type '\c' to clear the buffer.<br>
        <br>
        mysql&gt; <b>CREATE USER bungee@localhost IDENTIFIED BY
        '</b><b>PASSWORD</b><b>';</b><br style=FONT-WEIGHT:bold>
        <br>
        mysql&gt; <b>GRANT SELECT, INSERT, UPDATE, CREATE, DELETE, ALTER ROUTINE, EXECUTE, CREATE VIEW, 
	  CREATE TEMPORARY TABLES, DROP ON wpa.* TO
        bungee@localhost;</b><br style=FONT-WEIGHT:bold>
        <br>
        C:\Program Files\MySQL\MySQL Server 5.0\bin&gt;<b>exit</b><br>
        <br>
      </td>
    </tr>
    </tbody>
  </table>
</div>
<br>

</body>
</html>
